Preliminary DB2 performance benefits

Notes/Domino 8 Forum

Subject:

Actually, we've done that already as a quick pre-test. We had 1.5GB discussion database on a Domino8 DB/2 enabled server, and the views opened pretty fast. We don't care about unread marks, since we disable them always, and use our own logic to implement unread marks (including read and edit counters).

The immediate performance benefits of using a DB/2 database are:

1) Views will be indexed faster (this is actually quite a common problem in big ((>1GB or >100000 documents) Domino .NSF databases)

2) You can substitute some LotuScript/Java/@Formula code into native DB/2 inner joins, those will work much faster than joining each record by LotuScript/Java/@Formula language. However, not all joins can be substituted into native DB/2 joins, especially superrelational joins (since SQL doesn't support them (for example joining a certain word in a rich text field with some other field in another database, or joining different fields of different databases by some complex logic inluding lots of "if" and "case" etc... branches)).

Feedback response number WEBB77SNEQ created by ~Richard Minnitherlen on 10/08/2007

Return to top

NSFDB2 Performance (~Bella Opvelust... 5.Oct.07)

. . NSFDB2 Performance (~Richard Minnit... 6.Oct.07)

. . . . One thing you should try in your ev... (~Dana Prekipulo... 8.Oct.07)

. . . . . . Preliminary DB2 performance benefit... (~Richard Minnit... 8.Oct.07)

. . . . . . . . I think there is more to it than un... (~Dana Prekipulo... 8.Oct.07)

. . . . . . . . . . Bugs with NSFDB2 (~Bella Opvelust... 22.Oct.07)

. . . . . . . . . . . . I did supply a bug report through t... (~Dana Prekipulo... 23.Oct.07)

Printer-friendly

Search this forum

Member Tools

RSS Feeds

RSS feeds

	All forum posts RSS
	All main topics RSS